﻿/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 18:06:52
*/


-- ----------------------------
-- Table structure for tb2541
-- ----------------------------
DROP TABLE [dbo].[tb2541]
GO
CREATE TABLE [dbo].[tb2541] (
[QuitJobID] varchar(20) NOT NULL ,
[QuitJobName] nvarchar(50) NOT NULL ,
[Disabled] tinyint NOT NULL DEFAULT((0)) ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL 
)


GO

-- ----------------------------
-- Records of tb2541
-- ----------------------------
INSERT INTO [dbo].[tb2541] ([QuitJobID], [QuitJobName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'XTV', N'Xin thôi việc', N'0', N'2011-07-29 17:52:52.513', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[tb2541] ([QuitJobID], [QuitJobName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'GBC', N'Giảm biên chế', N'0', N'2011-07-29 17:52:32.640', N'admin', null, null)
GO
GO

-- ----------------------------
-- Indexes structure for table tb2541
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb2541
-- ----------------------------
ALTER TABLE [dbo].[tb2541] ADD PRIMARY KEY NONCLUSTERED ([QuitJobID])
GO
